/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package dal;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author Le Thai
 */
public class DsNamHocDAL {
    private DbAccess conn=new DbAccess();
    private Statement stm;
    private ResultSet res;
    private String sql;
    public DsNamHocDAL(){
    
    }
    
    //lay danh sach nam hoc
    public ResultSet getYearList(){
        res=null;
        conn.getDefaultConnection();
        sql="exec layDanhSachNamHoc";
        
        try {
            stm=conn.Connection().createStatement();
            res=stm.executeQuery(sql);
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
        return res;
    }
    
}
